SUPPORT / SAMPLES & SAS NOTES
Problem Note 55843: Reconfiguration of the SAS® Web Application Server fails because of the data source definition that is created by the previous configuration
 |  |  |  |
Removing the configuration for the SAS WebApplication Server does not remove the data source definition. As a result, multiple data source definitions are left in the server.xml file.
When you reconfigure an environment, the SAS® Deployment Wizard picks up the first data source definition in file rather than the newly created data source definition. When this problem happens, there might not be any symptoms or indications because the wizard picks up a data source definition (even if it is not the correct one).
As a workaround for this problem, you need to modify the server.xml file that resides in the SAS-configuration-directory\Levn\Web\WebAppServer\SASServerN_M\conf\ directory.
In the server.xml file:
- Search for the uniqueResourceName= parameter, as shown in the example below:
uniqueResourceName="sas/jdbc/MonitorDataSource" url="jdbc:oracle:thin:@localdb.na.sas.com:1523:localdb" - Change the JDBC URL (highlighted) to the correct URL value.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Application Server | Solaris for x64 | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| HP-UX IPF | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft® Windows® for x64 | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 | ||